<!-- SQL审计 -->
<template>
  <div class="app-container">
    <el-form v-show="showSearch" ref="queryForm" :model="queryParams" size="small" :inline="true" label-width="68px">
      <el-form-item label="执行时间" prop="queryTime">
        <el-date-picker
          v-model="dateRange"
          style="width: 240px"
          value-format="yyyy-MM-dd HH:mm:ss"
          type="daterange"
          range-separator="-"
          start-placeholder="开始时间"
          end-placeholder="结束时间"
          :default-time="['00:00:00', '23:59:59']"
        />
      </el-form-item>
      <el-form-item label="消耗时间" prop="elapsedTime">
        <el-input v-model="queryParams.elapsedTime" clearable placeholder="请输入最少消耗时间" @keyup.enter.native="handleQuery" />
      </el-form-item>
      <el-form-item>
        <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
      </el-form-item>
    </el-form>

    <el-row :gutter="10" class="mb8">
      <el-col :span="1.5">
        <el-button
          v-has-permi="['system:sqlLog:remove']"
          type="danger"
          icon="el-icon-delete"
          size="mini"
          plain
          :disabled="multiple"
          @click="handleDelete"
        >删除</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          v-has-permi="['system:sqlLog:remove']"
          type="danger"
          icon="el-icon-delete"
          size="mini"
          plain
          @click="handleClean"
        >清空</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          v-has-permi="['system:sqlLog:export']"
          type="warning"
          icon="el-icon-download"
          size="mini"
          plain
          @click="handleExport"
        >导出</el-button>
      </el-col>
      <right-toolbar :show-search.sync="showSearch" @queryTable="getList" />
    </el-row>

    <el-table v-loading="loading" :data="sqlLogList" @selection-change="handleSelectionChange">
      <el-table-column type="selection" width="55" align="center" />
      <el-table-column label="审计编号" align="center" prop="sqlId" />
      <el-table-column label="服务器 IP" align="center" prop="hostIp" />
      <el-table-column label="执行的 sql" align="center" prop="query" min-width="200" show-overflow-tooltip />
      <el-table-column label="参数" align="center" prop="queryParams" />
      <el-table-column label="执行时间" align="center" prop="queryTime" />
      <el-table-column label="消耗时间(毫秒)" align="center" prop="elapsedTime" />
      <el-table-column label="数据源" align="center" prop="dsName" />
      <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
        <template slot-scope="scope">
          <el-button
            v-has-permi="['system:sqlLog:query']"
            size="mini"
            type="text"
            icon="el-icon-view"
            @click="handleView(scope.row, scope.index)"
          >详细</el-button>
        </template>
      </el-table-column>
    </el-table>

    <pagination
      v-show="total>0"
      :total="total"
      :page.sync="queryParams.pageNumber"
      :limit.sync="queryParams.pageSize"
      @pagination="getList"
    />

    <!-- SQL审计详细对话框 -->
    <el-dialog title="SQL审计详细" :visible.sync="open" width="500px" append-to-body :close-on-click-modal="false">
      <el-form ref="form" :model="form" label-width="100px" size="mini">
        <el-row>
          <el-col :span="12">
            <el-form-item label="服务器 IP：" prop="hostIp">{{ form.hostIp }}</el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="数据源：" prop="dsName">{{ form.dsName }}</el-form-item>
          </el-col>
          <el-col :span="24">
            <el-form-item label="执行的 sql：" prop="query">{{ form.query }}</el-form-item>
          </el-col>
          <el-col :span="24">
            <el-form-item label="参数：" prop="queryParams">{{ form.queryParams }}</el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="执行时间：" prop="queryTime">{{ form.queryTime }}</el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="消耗时间：" prop="elapsedTime">{{ form.elapsedTime }}毫秒</el-form-item>
          </el-col>
        </el-row>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button @click="open = false">关 闭</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
import { listSqlLog, delSqlLog, cleanSqlLog } from '@/api/system/sqlLog'

export default {
  name: 'SqlLog',
  data() {
    return {
      // 遮罩层
      loading: true,
      // 选中数组
      ids: [],
      // 非单个禁用
      single: true,
      // 非多个禁用
      multiple: true,
      // 显示搜索条件
      showSearch: true,
      // 总条数
      total: 0,
      // SQL审计表格数据
      sqlLogList: [],
      // 是否显示弹出层
      open: false,
      // 日期范围
      dateRange: [],
      // 查询参数
      queryParams: {
        pageNumber: 1,
        pageSize: 10,
        platform: undefined,
        module: undefined,
        url: undefined,
        user: undefined,
        userIp: undefined,
        hostIp: undefined,
        query: undefined,
        queryParams: undefined,
        queryTime: undefined,
        elapsedTime: undefined,
        dsName: undefined
      },
      // 表单参数
      form: {}
    }
  },
  created() {
    this.getList()
  },
  methods: {
    /** 组装查询参数 */
    getQueryParams() {
      if (Array.isArray(this.dateRange)) {
        this.queryParams.startTime = this.dateRange[0]
        this.queryParams.endTime = this.dateRange[1]
      }
      return this.queryParams
    },
    /** 查询SQL审计列表 */
    getList() {
      this.loading = true
      listSqlLog(this.getQueryParams()).then(res => {
        this.sqlLogList = res.list
        this.total = Number(res.total)
        this.loading = false
      })
    },
    /** 搜索按钮操作 */
    handleQuery() {
      this.queryParams.pageNumber = 1
      this.getList()
    },
    /** 重置按钮操作 */
    resetQuery() {
      this.dateRange = []
      this.$resetForm('queryForm')
      this.handleQuery()
    },
    // 多选框选中数据
    handleSelectionChange(selection) {
      this.ids = selection.map(item => item.sqlId)
      this.single = selection.length !== 1
      this.multiple = !selection.length
    },
    /** 详细按钮操作 */
    handleView(row) {
      this.form = row
      this.open = true
    },
    /** 删除按钮操作 */
    handleDelete(row) {
      const sqlIds = row.sqlId || this.ids
      this.$modal.confirm('是否确认删除SQL审计编号为"' + sqlIds + '"的数据项？').then(function() {
        return delSqlLog(sqlIds)
      }).then(() => {
        this.getList()
        this.$modal.msgSuccess('删除成功')
      }).catch(() => {})
    },
    /** 清空按钮操作 */
    handleClean() {
      this.$modal.confirm('是否确认清空所有SQL审计数据项？').then(function() {
        return cleanSqlLog()
      }).then(() => {
        this.getList()
        this.$modal.msgSuccess('清空成功')
      }).catch(() => {})
    },
    /** 导出按钮操作 */
    handleExport() {
      this.$download('system/sqlLog/export', {
        ...this.getQueryParams()
      }, `sqlLog_${new Date().getTime()}.xls`)
    }
  }
}
</script>
